package com.ityuxin.dao;

import com.ityuxin.domain.ServiceItemlist;
import org.apache.ibatis.annotations.*;

import java.util.List;

/**
 * @Author: yyh
 * @Description:
 * @Date:Create：in 2021/4/3 12:12
 * @Modified By：
 */
public interface ServiceitemMapper {

    @Select("select *  from   serviceitemlist")
    List<ServiceItemlist> findAll();

    @Insert("insert into serviceitemlist values(null,#{createTime},#{serviceName},#{orderTime},#{remark},#{station},#{telephone}) ")
    void addserviceitem(ServiceItemlist serviceItemlist);

    @Update("update serviceitemlist set  createTime=#{createTime},serviceName=#{serviceName},orderTime=#{orderTime},remark=#{remark},station=#{station},telephone=#{telephone} where id=#{id} ")
    void updateserviceitem(ServiceItemlist serviceItemlist);

    @Delete("delete from serviceitemlist where id = #{id} ")
    void deleteById(Integer id);

    @Select("select  *  from serviceitemlist where id = #{id}")
    ServiceItemlist findById(@Param("id") Integer id);
}
